{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TITULAR","TITULAR + CONYUGE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TITULAR","index":0,"n_rows":98,"n_cols":21,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Monto Solicitado",50000,null,null,null,null,null,null,null,"Sí"]
[null,"Seguro de Vida",{"$f":"+IF(C9=\"Sí\",1.34%,3.3%)","v":3.3000000000000002E-2}]
[null,"Monto adicional Seguro Vida"]
[null,"Monto a Financiar",{"$f":"+C2+C4","v":50000}]
[null,"Seguro Desempleo",0,null,null,null,null,null,null,null,"No"]
[null,"Monto adicional desempleo",{"$f":"C6*C5","v":0}]
[null,"MAF Total",{"$f":"C7+C5","v":50000}]
[null,"Empleado","No"]
[null,"Moneda","Soles"]
[null,"Plazo Remanente",12]
[null,"Fecha de Desembolso","2022-03-17"]
[null,"Fecha de 1er Pago","2022-04-16"]
[null,"Cuota Julio",1]
[null,"Cuota Diciembre",1]
[null,"TEA",0.13]
[null,"TEA TOTAL",{"$f":"+C16","v":0.13}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C8+((C19*C18)+C20)*P25)/O25","v":4453.2755318634872}]
[]
[null,"TCEA",0.12999967502284068]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8-U25-C7-C4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O27:O98)","v":11.227690638552819},{"$f":"SUM(P27:P98)","v":11.227690638552819},null,null,null,null,{"$f":"SUM(U27:U98)","v":50000}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"C13","v":"2022-04-16"},{"$f":"IF(B27<=$C$11,WEEKDAY(C27,2),\"\")","v":6},{"$f":"IF(D27=7,C27+1,C27)","v":"2022-04-16"},{"$f":"E27-C12","v":30},{"$f":"F27","v":30},{"$f":"C8","v":50000},{"$f":"IF(B27>C$11,\"\",M27-L27-K27-J27)","v":3941.433313954667},{"$f":"IF(B27>C$11,\"\",((1+C$16)^(F27/360)-1)*H27)","v":511.84221790882003},{"$f":"IF(B27>C$11,\"\",C$18*C$19)","v":0},{"$f":"IF(B27>C$11,\"\",C$20)","v":0},{"$f":"IF(B27>C$11,\"\",IF(B27=C$11,H27+J27+K27+L27,IF(AND(C$14=2,MONTH(E27)=7),2*C$21,IF(AND(C$15=2,MONTH(E27)=12),2*C$21,C$21))))","v":4453.2755318634872},{"$f":"IF(B27>C$11,\"\",H27-I27)","v":46058.566686045335},{"$f":"IFERROR(IF(AND(MONTH(E27)=7,C$14=2),2/(1+C$17)^(G27/360),IF(AND(MONTH(E27)=12,C$15=2),2/(1+C$17)^(G27/360),1/(1+C$17)^(G27/360))),\"\")","v":0.98986688674507806},{"$f":"IFERROR(1/(1+C$17)^(G27/360),\"\")","v":0.98986688674507806},null,{"$f":"IFERROR(I27+J27+K27+L27,\"\")","v":4453.2755318634872},{"$f":"G27","v":30},{"$f":"IFERROR((1+C$23)^(S27/360),\"\")","v":1.0102368201469711},{"$f":"IFERROR(ROUND(R27/T27,2),\"\")","v":4408.1499999999996}]
[null,2,{"$f":"IF(B28>$C$11,\"\",EDATE(C27,1))","v":"2022-05-16"},{"$f":"IF(B28<=$C$11,WEEKDAY(C28,2),\"\")","v":1},{"$f":"IF(D28=7,C28+1,C28)","v":"2022-05-16"},{"$f":"IF(B28>C$11,\"\",E28-E27)","v":30},{"$f":"IFERROR(F28+G27,\"\")","v":60},{"$f":"IF(B28>C$11,\"\",N27)","v":46058.566686045335},{"$f":"IF(B28>C$11,\"\",M28-L28-K28-J28)","v":3981.7811533377526},471.4943785257347,0,0,{"$f":"IF(B28>C$11,\"\",IF(B28=C$11,H28+J28+K28+L28,IF(AND(C$14=2,MONTH(E28)=7),2*C$21,IF(AND(C$15=2,MONTH(E28)=12),2*C$21,C$21))))","v":4453.2755318634872},42076.785532707581,0.97983645347439319,0.97983645347439319,null,{"$f":"IFERROR(I28+J28+K28+L28,\"\")","v":4453.2755318634872},60,1.0205784327806637,4363.4799999999996]
[null,3,"2022-06-16",4,"2022-06-16",{"$f":"IF(B29>C$11,\"\",E29-E28)","v":31},91,42076.785532707581,4008.1085541831544,445.16697768033276,0,0,4453.2755318634872,38068.676978524425,0.96957843833485668,0.96957843833485668,null,4453.2755318634872,91,1.0313759957584423,4317.8]
[null,4,"2022-07-16",6,"2022-07-16",30,121,38068.676978524425,4063.5724107126398,389.70312115084755,0,0,4453.2755318634872,34005.104567811788,0.95975359020967921,0.95975359020967921,null,4453.2755318634872,121,1.0419340063309248,4274.05]
[null,5,"2022-08-16",2,"2022-08-16",31,152,34005.104567811788,4093.505900355176,359.76963150831136,0,0,4453.2755318634872,29911.598667456612,0.94970582476506293,0.94970582476506293,null,4453.2755318634872,152,1.0529575079949711,4229.3]
[null,6,"2022-09-16",5,"2022-09-16",31,183,29911.598667456612,4136.8146661438841,316.46086571960353,0,0,4453.2755318634872,25774.784001312728,0.93976325047728082,0.93976325047728082,null,4453.2755318634872,183,1.0640976366125472,4185.03]
[null,7,"2022-10-16",7,"2022-10-17",31,214,25774.784001312728,4180.5816331028836,272.69389876060336,0,0,4453.2755318634872,21594.202368209844,0.92992476608859209,0.92992476608859209,null,4453.2755318634872,214,1.0753556260788979,4141.21]
[null,8,"2022-11-16",3,"2022-11-16",30,244,21594.202368209844,4232.2190431811587,221.05648868232839,0,0,4453.2755318634872,17361.983325028687,0.92050173311525973,0.92050173311525973,null,4453.2755318634872,244,1.0863638482171012,4099.25]
[null,9,"2022-12-16",5,"2022-12-16",30,274,17361.983325028687,4275.5436108159147,177.73192104757265,0,0,4453.2755318634872,13086.439714212771,0.91117418480225076,0.91117418480225076,null,4453.2755318634872,274,1.0974847595454709,4057.71]
[null,10,"2023-01-16",1,"2023-01-16",31,305,13086.439714212771,4314.8226832816126,138.45284858187466,0,0,4453.2755318634872,8771.6170309311583,0.90163500247308404,0.90163500247308404,null,4453.2755318634872,305,1.1090959796415665,4015.23]
[null,11,"2023-02-16",4,"2023-02-16",31,336,8771.6170309311583,4360.4729521608715,92.802579702615589,0,0,4453.2755318634872,4411.1440787702868,0.89219568688841777,0.89219568688841777,null,4453.2755318634872,336,1.1208300446618831,3973.19]
[null,12,"2023-03-16",4,"2023-03-16",28,364,4411.1440787702868,4411.1440787702868,42.131453093214468,0,0,4453.2755318635009,0,0.88375482117886284,0.88375482117886284,null,4453.2755318635009,364,1.1315352236270919,3935.6]
[null,13,"","","","","","","","","","","","","","",null,"","","",""]
[null,14,"","","","","","","","","","","","","","",null,"","","",""]
[null,15,"","","","","","","","","","","","","","",null,"","","",""]
[null,16,"","","","","","","","","","","","","","",null,"","","",""]
[null,17,"","","","","","","","","","","","","","",null,"","","",""]
[null,18,"","","","","","","","","","","","","","",null,"","","",""]
[null,19,"","","","","","","","","","","","","","",null,"","","",""]
[null,20,"","","","","","","","","","","","","","",null,"","","",""]
[null,21,"","","","","","","","","","","","","","",null,"","","",""]
[null,22,"","","","","","","","","","","","","","",null,"","","",""]
[null,23,"","","","","","","","","","","","","","",null,"","","",""]
[null,24,"","","","","","","","","","","","","","",null,"","","",""]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B91<=$C$11,WEEKDAY(C91,2),\"\")","v":""},"","","","","",{"$f":"IF(B91>C$11,\"\",((1+C$16)^(F91/360)-1)*H91)","v":""},{"$f":"IF(B91>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B91>C$11,\"\",C$20)","v":""},"",{"$f":"IF(B91>C$11,\"\",H91-I91)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E91)=7,C$14=2),2/(1+C$17)^(G91/360),IF(AND(MONTH(E91)=12,C$15=2),2/(1+C$17)^(G91/360),1/(1+C$17)^(G91/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$17)^(G91/360),\"\")","v":""},null,"",{"$f":"G91","v":""},{"$f":"IFERROR((1+C$23)^(S91/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R91/T91,2),\"\")","v":""}]
[null,66,{"$f":"IF(B92>$C$11,\"\",EDATE(C91,1))","v":""},"",{"$f":"IF(D92=7,C92+1,C92)","v":""},{"$f":"IF(B92>C$11,\"\",E92-E91)","v":""},{"$f":"IFERROR(F92+G91,\"\")","v":""},{"$f":"IF(B92>C$11,\"\",N91)","v":""},{"$f":"IF(B92>C$11,\"\",M92-L92-K92-J92)","v":""},"","","",{"$f":"IF(B92>C$11,\"\",IF(B92=C$11,H92+J92+K92+L92,IF(AND(C$14=2,MONTH(E92)=7),2*C$21,IF(AND(C$15=2,MONTH(E92)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I92+J92+K92+L92,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]

{"sheet":"TITULAR + CONYUGE","index":1,"n_rows":98,"n_cols":21,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Monto Solicitado",0,null,null,null,null,null,null,null,"Sí"]
[null,"Seguro de Vida",{"$f":"+IF(C9=\"Sí\",2.68%,6.6%)","v":6.6000000000000003E-2}]
[null,"Monto adicional Seguro Vida",{"$f":"+C3*C2","v":0}]
[null,"Monto a Financiar",{"$f":"+C2+C4","v":0}]
[null,"Seguro Desempleo",0,null,null,null,null,null,null,null,"No"]
[null,"Monto adicional desempleo",{"$f":"C6*C5","v":0}]
[null,"MAF Total",{"$f":"C7+C5","v":0}]
[null,"Empleado","No"]
[null,"Moneda","Soles"]
[null,"Plazo Remanente",0]
[null,"Fecha de Desembolso",{"$f":"TODAY()","v":"2022-03-17"}]
[null,"Fecha de 1er Pago",{"$f":"EDATE(C12,1)","v":"2022-04-17"}]
[null,"Cuota Julio",1]
[null,"Cuota Diciembre",1]
[null,"TEA",0]
[null,"TEA TOTAL",{"$f":"+C16","v":0}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C8+(C19*C18+C20)*P25)/O25","v":0}]
[]
[null,"TCEA",0.16941779982252866]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8-U25-C7-C4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O27:O98)","v":1},{"$f":"SUM(P27:P98)","v":1},null,null,null,null,{"$f":"SUM(U27:U98)","v":0}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"C13","v":"2022-04-17"},{"$f":"IF(B27<=$C$11,WEEKDAY(C27,2),\"\")","v":""},{"$f":"IF(D27=7,C27+1,C27)","v":"2022-04-17"},{"$f":"E27-C12","v":31},{"$f":"F27","v":31},{"$f":"C8","v":0},{"$f":"IF(B27>C$11,\"\",M27-L27-K27-J27)","v":""},{"$f":"IF(B27>C$11,\"\",((1+C$16)^(F27/360)-1)*H27)","v":""},{"$f":"IF(B27>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B27>C$11,\"\",C$20)","v":""},{"$f":"IF(B27>C$11,\"\",IF(B27=C$11,H27+J27+K27+L27,IF(AND(C$14=2,MONTH(E27)=7),2*C$21,IF(AND(C$15=2,MONTH(E27)=12),2*C$21,C$21))))","v":""},{"$f":"IF(B27>C$11,\"\",H27-I27)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E27)=7,C$14=2),2/(1+C$17)^(G27/360),IF(AND(MONTH(E27)=12,C$15=2),2/(1+C$17)^(G27/360),1/(1+C$17)^(G27/360))),\"\")","v":1},{"$f":"IFERROR(1/(1+C$17)^(G27/360),\"\")","v":1},null,{"$f":"IFERROR(I27+J27+K27+L27,\"\")","v":""},{"$f":"G27","v":31},{"$f":"IFERROR((1+C$23)^(S27/360),\"\")","v":1.0135681299557451},{"$f":"IFERROR(ROUND(R27/T27,2),\"\")","v":""}]
[null,2,{"$f":"IF(B28>$C$11,\"\",EDATE(C27,1))","v":""},"",{"$f":"IF(D28=7,C28+1,C28)","v":""},{"$f":"IF(B28>C$11,\"\",E28-E27)","v":""},{"$f":"IFERROR(F28+G27,\"\")","v":""},{"$f":"IF(B28>C$11,\"\",N27)","v":""},{"$f":"IF(B28>C$11,\"\",M28-L28-K28-J28)","v":""},"","","",{"$f":"IF(B28>C$11,\"\",IF(B28=C$11,H28+J28+K28+L28,IF(AND(C$14=2,MONTH(E28)=7),2*C$21,IF(AND(C$15=2,MONTH(E28)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I28+J28+K28+L28,\"\")","v":""},"","",""]
[null,3,"","","","","","","","","","","","","","",null,"","","",""]
[null,4,"","","","","","","","","","","","","","",null,"","","",""]
[null,5,"","","","","","","","","","","","","","",null,"","","",""]
[null,6,"","","","","","","","","","","","","","",null,"","","",""]
[null,7,"","","","","","","","","","","","","","",null,"","","",""]
[null,8,"","","","","","","","","","","","","","",null,"","","",""]
[null,9,"","","","","","","","","","","","","","",null,"","","",""]
[null,10,"","","","","","","","","","","","","","",null,"","","",""]
[null,11,"","","","","","","","","","","","","","",null,"","","",""]
[null,12,"","","","","","","","","","","","","","",null,"","","",""]
[null,13,"","","","","","","","","","","","","","",null,"","","",""]
[null,14,"","","","","","","","","","","","","","",null,"","","",""]
[null,15,"","","","","","","","","","","","","","",null,"","","",""]
[null,16,"","","","","","","","","","","","","","",null,"","","",""]
[null,17,"","","","","","","","","","","","","","",null,"","","",""]
[null,18,"","","","","","","","","","","","","","",null,"","","",""]
[null,19,"","","","","","","","","","","","","","",null,"","","",""]
[null,20,"","","","","","","","","","","","","","",null,"","","",""]
[null,21,"","","","","","","","","","","","","","",null,"","","",""]
[null,22,"","","","","","","","","","","","","","",null,"","","",""]
[null,23,"","","","","","","","","","","","","","",null,"","","",""]
[null,24,"","","","","","","","","","","","","","",null,"","","",""]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B91<=$C$11,WEEKDAY(C91,2),\"\")","v":""},"","","","","",{"$f":"IF(B91>C$11,\"\",((1+C$16)^(F91/360)-1)*H91)","v":""},{"$f":"IF(B91>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B91>C$11,\"\",C$20)","v":""},"",{"$f":"IF(B91>C$11,\"\",H91-I91)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E91)=7,C$14=2),2/(1+C$17)^(G91/360),IF(AND(MONTH(E91)=12,C$15=2),2/(1+C$17)^(G91/360),1/(1+C$17)^(G91/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$17)^(G91/360),\"\")","v":""},null,"",{"$f":"G91","v":""},{"$f":"IFERROR((1+C$23)^(S91/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R91/T91,2),\"\")","v":""}]
[null,66,{"$f":"IF(B92>$C$11,\"\",EDATE(C91,1))","v":""},"",{"$f":"IF(D92=7,C92+1,C92)","v":""},{"$f":"IF(B92>C$11,\"\",E92-E91)","v":""},{"$f":"IFERROR(F92+G91,\"\")","v":""},{"$f":"IF(B92>C$11,\"\",N91)","v":""},{"$f":"IF(B92>C$11,\"\",M92-L92-K92-J92)","v":""},"","","",{"$f":"IF(B92>C$11,\"\",IF(B92=C$11,H92+J92+K92+L92,IF(AND(C$14=2,MONTH(E92)=7),2*C$21,IF(AND(C$15=2,MONTH(E92)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I92+J92+K92+L92,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]